select count(*) from tblDetailSurvey
select count(*) from tblSurveyQuestion
select count(*) from [tblMasterEmpSurvey]

--Master with Comments
http://web2.teledirect.com.sg/tdintranet/rpt_SSS_Raw.aspx

--Details
SELECT M.[SurveyID]
      ,M.[ApplicantName]
      ,M.[SurveyDate]
      ,M.[Department]
      ,M.[JobLevel]
      ,M.[TDExp]
      ,M.[AgeGroup]
	  ,Q.QuestionGroup
	  ,Q.Question
	  ,D.Answers
  FROM [dbo].[tblMasterEmpSurvey] M 
  INNER JOIN tblDetailSurvey D ON M.SurveyID = D.SurveyID
  INNER JOIN tblSurveyQuestion Q ON D.QuestionID = Q.QuestionID
  --Where M.SurveyID = 429
GO

